Posts filtered by the tag - %20Bds2006 | Wilton Software Limited

Sitemap / Contact / Home

(default) 13 queries took 34 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `posts`	17	17	1
2	DESCRIBE `comments`	11	11	1
3	DESCRIBE `tags`	2	2	1
4	DESCRIBE `categories`	2	2	11
5	DESCRIBE `posts_tags`	2	2	7
6	DESCRIBE `categories_posts`	2	2	2
7	SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('%20Bds2006') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC	0	0	4
8	SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category	15	15	2
9	SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag	49	49	1
10	SELECT COUNT(*) AS `count` FROM `posts` AS `Post` WHERE `Post`.`status` = 1	1	1	1
11	SELECT `Post`.`id`, `Post`.`url`, `Post`.`title`, `Post`.`icon`, `Post`.`metadesc`, `Post`.`metakeys`, `Post`.`categories`, `Post`.`tease`, `Post`.`body`, `Post`.`private_body`, `Post`.`created`, `Post`.`modified`, `Post`.`status`, `Post`.`allow_comments`, `Post`.`tags`, `Post`.`hitcount`, `Post`.`hitcount_rss` FROM `posts` AS `Post` WHERE `Post`.`status` = 1 ORDER BY `Post`.`created` desc LIMIT 10	10	10	1
12	SELECT COUNT(*) AS `count` FROM `posts` AS `Post` WHERE `Post`.`status` = 1	1	1	1
13	SELECT `Post`.`id`, `Post`.`url`, `Post`.`title`, `Post`.`icon`, `Post`.`metadesc`, `Post`.`metakeys`, `Post`.`categories`, `Post`.`tease`, `Post`.`body`, `Post`.`private_body`, `Post`.`created`, `Post`.`modified`, `Post`.`status`, `Post`.`allow_comments`, `Post`.`tags`, `Post`.`hitcount`, `Post`.`hitcount_rss` FROM `posts` AS `Post` WHERE `Post`.`status` = 1 ORDER BY `Post`.`hitcount` desc LIMIT 10	10	10	1

(default) 13 queries took 34 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `posts`

DESCRIBE `comments`

DESCRIBE `tags`

DESCRIBE `categories`

DESCRIBE `posts_tags`

DESCRIBE `categories_posts`

SELECT Post.* FROM posts Post, posts_tags pt, tags t WHERE t.tag = ('%20Bds2006') AND t.id = pt.tag_id AND pt.post_id = Post.id AND Post.status = 1 ORDER BY Post.created DESC

SELECT category, COUNT(*) AS cat_cnt FROM categories_posts c2p INNER JOIN categories Cat ON c2p.category_id = Cat.id GROUP BY category

SELECT tag, COUNT(*) AS tag_cnt FROM posts_tags t2p INNER JOIN tags Tag ON t2p.tag_id = Tag.id GROUP BY tag

SELECT COUNT(*) AS `count` FROM `posts` AS `Post` WHERE `Post`.`status` = 1

SELECT `Post`.`id`, `Post`.`url`, `Post`.`title`, `Post`.`icon`, `Post`.`metadesc`, `Post`.`metakeys`, `Post`.`categories`, `Post`.`tease`, `Post`.`body`, `Post`.`private_body`, `Post`.`created`, `Post`.`modified`, `Post`.`status`, `Post`.`allow_comments`, `Post`.`tags`, `Post`.`hitcount`, `Post`.`hitcount_rss` FROM `posts` AS `Post` WHERE `Post`.`status` = 1 ORDER BY `Post`.`created` desc LIMIT 10

SELECT COUNT(*) AS `count` FROM `posts` AS `Post` WHERE `Post`.`status` = 1

Tag Filter - (%20Bds2006)

Categories

Tags

Site Sections

Blog Categories

Latest

Popular